package com.jash.labor.mapper.provider;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import java.sql.SQLOutput;

public class sqlStationProvider {

    public String HistoricalPositionList(Page page, String companyid){
        System.out.println(companyid);

        String sql = "SELECT f.name fname,first_party_id,recr_time_start, \n" +
                "recr_time_end,s.name FROM first_party f,station s \n" +
                "WHERE f.id = s.first_party_id and company_id = "+companyid;
      sql += "order by s.id desc";
        return sql;
    }
}
